Databases

This information is relevant only if you own a Fisa Logger License. See Fisa Logger

Contents



Databases

Fisa Logger databases have the extension *.cmb. File Extensions

These databases are only used for saving Production data with Fisa Logger License.

The databases can be opened with Access 2000 (included in Microsft Office 2000 Professional) or later. By default, the databases are password protected. You can change or remove the password. How to change the Password

Fisa Logger works with two databases:

  • Logger Master.cmb
  • Logger.cmb

    Logger Master serves as the template for creating a new Installation.cmb (working database). Logger.cmb will be named as your Installation name, eg My First Installation.cmb. The structure of the Logger.cmb will therefore be the same as for Logger Master.cmb, except for the table Operators which exists only in the Logger Master.cmb.


    Logger Master.cmb

    Located in the application path

    You need to know the password for Logger Master.mdb to enter in Supervisor Mode. Supervisor Mode


    Logger.cmb

    Located in the same path as the *.cmg file.
    Normally \Fisa Software\Fisa Project\Installations\MyFirst Installation.cmb.
    File Extensions

    This database is created as a copy of Logger Master.cmb whenever creating a new installation. The Logger.cmb could also be created if it is not found at the same location as the *.cmg file.

    The Logger.cmb can have a different password than the one in Logger Master.cmb.


    Structure




    How Data are Created and Saved




    Queries

    The most important queries for data mining in the Logger database are already included in Fisa Logger. The Baskets Analyzer

    This does not exclude that you might want to prepare your own, more refined, queries based on the stucture described above.


    Query Example

    A query like this one is easily constructed in the Access 2000 Query design interface:

    The produced SQL string looks like this:

    SELECT Baskets.*, Baskets.Barcode FROM ((Operators INNER JOIN [Session] ON Operators.Operator = Session.Operator) INNER JOIN Baskets ON Session.Counter = Baskets.SessionID) INNER JOIN Visits ON Baskets.Counter = Visits.BasketsID WHERE (((Baskets.Barcode) Like "????###AB*"));